<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Block</title>
<style type="text/css">
<!--
.style3 {font-size: 9px}
-->
</style>
</head>

<body>
<?php
include("../connection/connection.php");
include("reportFunctions.php");
$distId=$_REQUEST['distId'];
$sqlReport = "SELECT sum(cwr_total) as CWR,sum(glsr_total) as GLSR,sum(glr_total) as GLR,sum(ohsr_total) as OHSR FROM `tbl_dtls_q1_main` where district_id=".$distId;
$queryReport = mysql_query($sqlReport);
?>
<table border="0" width="800" cellspacing="0" cellpadding="0">
	<tr>
		<td bgcolor="#E9E9E9" height="26">
		<p align="center"><span style="font-size: 9pt; font-weight: 700">
		<font face="Verdana" color="#224568">&nbsp;Storage structures for 
		district (as per PHED)Table 5 </font></span></td>
	</tr>
	<tr>
	  <td bgcolor="#E9E9E9" height="26"><p align="center" class="style3"><font face="Verdana" style="font-size: 9pt; font-weight: 700" color="#224568">Table 4 </font></p></td>
  </tr>
	<tr>
		<td bgcolor="#E9E9E9" height="56">
		<table border="1" width="800" cellspacing="0" cellpadding="0" height="61" bgcolor="#C5D8EB">
			<tr>
			
				<td width="40" align="center">
				<p align="center"><font face="Verdana" style="font-size: 8.5pt">
				S. No.</font></td>
				<td width="338" align="center">
				<font face="Verdana" style="font-size: 8.5pt">Type of Reservoirs</font></td>
				<td align="center">
				<font face="Verdana" style="font-size: 8.5pt">No. of Reservoirs</font></td>
			</tr>
		</table></td>
	</tr>
	<tr>
	<td>
		<table border="1" width="800" cellspacing="0" cellpadding="0" height="49" bordercolor="#C5D8EB" style="border: 1px solid #BBD1E8" bgcolor="#F9F9F9">
			<?php 
			$slNo=1;
			while($rowReport = mysql_fetch_array($queryReport)) {
			?><tr><td width="40" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $slNo;$slNo++; ?></font></td>
				<td width="338" align="center"><font face="Verdana" style="font-size: 8.5pt">CWR</font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $rowReport['CWR']; ?></font></td>
				</tr>
				<tr><td width="40" align="center"<font face="Verdana" style="font-size: 8.5pt"><?php echo $slNo;$slNo++; ?></font></td>
				<td width="338" align="center"><font face="Verdana" style="font-size: 8.5pt">GLR</font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $rowReport['GLR']; ?></td>
				</tr>
				<tr><td width="40" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $slNo;$slNo++; ?></font></td>
				<td width="338" align="center"><font face="Verdana" style="font-size: 8.5pt">GLSR</font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $rowReport['GLSR']; ?></font></td>
				</tr>
				<tr><td width="40" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $slNo;$slNo++; ?></font></td>
				<td width="338" align="center"><font face="Verdana" style="font-size: 8.5pt">OHSR</font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $rowReport['OHSR']; ?></font></td>
				</tr>
				
			<?php
			$totalSource = $rowReport['OHSR'] + $rowReport['GLR'] + $rowReport['GLSR'] + $rowReport['CWR'];
			}
			?>
			<tr><td width="40" align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="338" align="center"><font face="Verdana" style="font-size: 8.5pt">Total</font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo $totalSource; ?></font></td>
			</tr></td>
		</table></td></tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>



</body>

</html>
